package com.hyst.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.hyst.model.ExamineRecord;

public interface ExamineRecord_Repository  extends  JpaRepository<ExamineRecord, String>  {

	@Query(value = "select * from examine_record where worker_id=?1  AND start_time >=?2  AND finish_time <=?3", nativeQuery = true)
	List<ExamineRecord> findAllByUserID(String worker_id, String starttime, String endtime);
}
